UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B/1SCiD+mj7EX0owSFvxIcIHYgxnkHZNRUMPAjs1rZ0='
WHERE
key_id = '249fa1ab54c0d5e3458891be17c8003ab30d0f56102a332c65667ea0dfa9ca2d'
AND (
token = 'B/1SCiD+mj7EX0owSFvxIcIHYgxnkHZNRUMPAjs1rZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)