UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LNBhBcICpqQ1AS4VdAG77eRM5yIILmz06TfGuLdm9l4='
WHERE
key_id = 'b97ddebe380758db5da671b3aa4835af30edd702ce6f2b0a5bd48dd6273600a9'
AND (
token = 'LNBhBcICpqQ1AS4VdAG77eRM5yIILmz06TfGuLdm9l4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)