UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w7MxrzGh06ODD2bPGUTEEeTH8MI/Kif6Teu6TJ2UbtI='
WHERE
key_id = 'abf8097246ded1aa41bc0cdc872d70df4d8f8b317980ca45edf0e66e5dce3749'
AND (
token = 'w7MxrzGh06ODD2bPGUTEEeTH8MI/Kif6Teu6TJ2UbtI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)