UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EQWrfA9eJa0WmvVfmi/2/mfGyOdXcYgZqXV18kNhWIU='
WHERE
key_id = '1b7689403637112242946edd44f45c9790ae9049ac8291caf36f2147c6179ddf'
AND (
token = 'EQWrfA9eJa0WmvVfmi/2/mfGyOdXcYgZqXV18kNhWIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)