UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XkrptK9+YyE7ePW32hCugY66ijNzL3uoyyxhoaNtpws='
WHERE
key_id = 'c16e0821d5fad5b5061efb1e24eda18af8c63792545c5ee26fb717afc454d34a'
AND (
token = 'XkrptK9+YyE7ePW32hCugY66ijNzL3uoyyxhoaNtpws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)