UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5bHrqoSuowq9NxfqN1E6iyAK7d7y4PA+mUutyKhCovc='
WHERE
key_id = 'ab27173a541228bd06dc1793c2c646142b6a5b9d58cb72c14cf94a21adea842a'
AND (
token = '5bHrqoSuowq9NxfqN1E6iyAK7d7y4PA+mUutyKhCovc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)