UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YnNLjXa5linLpNT75np67OB7BFqkMbn4HMn9+CInxBU='
WHERE
key_id = '9e6c6505a9c4be501931540c5fad8c8be7da5976c9cd60624d758da139a22512'
AND (
token = 'YnNLjXa5linLpNT75np67OB7BFqkMbn4HMn9+CInxBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)