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