UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DIH8ebv/2lCA8kaffFjJSKgExR9ZbE4IvCPBfjj3O/c='
WHERE
key_id = 'de981b29cf99c0be2180be86f43244479d564858996d8ad986f9630dc919f9ff'
AND (
token = 'DIH8ebv/2lCA8kaffFjJSKgExR9ZbE4IvCPBfjj3O/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)