UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FefmPRNXePuGOEZGVU5fx0ragn8iHEYvt8v+VtBg9sE='
WHERE
key_id = 'f6410a65871bc7591132e7cf76aa3ddb68971fc8436143e40caf1e33111637bf'
AND (
token = 'FefmPRNXePuGOEZGVU5fx0ragn8iHEYvt8v+VtBg9sE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)