UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qPCL041IDCKBNlc9n4ACbTtTcnTMTjRY53/80O9E4GI='
WHERE
key_id = 'd9ec8b938c634bab74a74d816a71f4450cc5ed2d4d03ebced991b86c69e23402'
AND (
token = 'qPCL041IDCKBNlc9n4ACbTtTcnTMTjRY53/80O9E4GI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)