UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1HwPEaWzYnKo0lwIicf0anrGnU8SLSAbfiYLyki3qE='
WHERE
key_id = 'd1f443ffd3218cec1fdbb6f30d4b3e6f51931a499dae7e8f1bc041f6136320f2'
AND (
token = 'x1HwPEaWzYnKo0lwIicf0anrGnU8SLSAbfiYLyki3qE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)