UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H12nMqvfjkxdINTPIzLk7ppdn3C/SpLBh7+rOH+aUH0='
WHERE
key_id = 'e1494746ef31938cf62002b9df430de736cf3129f3605db902670de4fa1c6c7e'
AND (
token = 'H12nMqvfjkxdINTPIzLk7ppdn3C/SpLBh7+rOH+aUH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)