UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zU1Gty+rpjA4dfC0hlEG6ChhcLL1FyX7Y37QrUxX73E='
WHERE
key_id = 'f5c14a716aa3b9bac2ea09fd1e2ae69af5d8e27b3fed1e5593776360b3c9dc9e'
AND (
token = 'zU1Gty+rpjA4dfC0hlEG6ChhcLL1FyX7Y37QrUxX73E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)