UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0sFoCn7sZv3ZzojxoCSl//vP9IVS/C/g5VLghqSjvlI='
WHERE
key_id = '47c38a75d28c34815e6c5c90eac591e53c7d9223eb90823e75b288651f4168ab'
AND (
token = '0sFoCn7sZv3ZzojxoCSl//vP9IVS/C/g5VLghqSjvlI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)