UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BxapVXkK/ho9jpMAXLUakKKYuDlI1/MruhkPq3Yeg4='
WHERE
key_id = '1edb307ea3c336e36d949c8007fc19c8e22de73d7989d5cb37025680ceadd664'
AND (
token = '1BxapVXkK/ho9jpMAXLUakKKYuDlI1/MruhkPq3Yeg4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)