UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LQa3e5jRfWPsMaK3DTRMThkrsK0RfdFU5MFFY1EFxWo='
WHERE
key_id = '808dccf30d461fe955548e907d89a7d03c61aaab8e54b9d095a205022a32cbed'
AND (
token = 'LQa3e5jRfWPsMaK3DTRMThkrsK0RfdFU5MFFY1EFxWo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)