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