UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'siImDZx0PPF5PL4BJOlutBKDy+NlQiA8U+fXfCrI8Gw='
WHERE
key_id = '10c6b46618d610caa00c4068660c59a91a23aa81d335b4861c96272775ff3e74'
AND (
token = 'siImDZx0PPF5PL4BJOlutBKDy+NlQiA8U+fXfCrI8Gw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)