UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q7gyZ2UstquG4qydYMkpcmyGjIyJAPsKMP5/gWSgFzY='
WHERE
key_id = '188774408c7b65bb704fc2e7bfe46e384acaf0af8e3162379d03167dd39f088c'
AND (
token = 'Q7gyZ2UstquG4qydYMkpcmyGjIyJAPsKMP5/gWSgFzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)