UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00QLuMbFTDRJc9FgxBL4V8zmEDQ4I8Qncv0agyBdods='
WHERE
key_id = '7e72597370aa427327f443a9876a5a9ed360348aa21b91e38165ad8eeebd9706'
AND (
token = '00QLuMbFTDRJc9FgxBL4V8zmEDQ4I8Qncv0agyBdods='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)