UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bnodIKLatB3La1O7E2lA+fqKEp28vrlj4Ffhyiqkgos='
WHERE
key_id = 'b566126ca264b538d4094e4b46b78eb5fe44745a6a331e7e56ef8fe4968c325b'
AND (
token = 'bnodIKLatB3La1O7E2lA+fqKEp28vrlj4Ffhyiqkgos='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)