UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZrLH+X9D5FwJL4fZqiN8caiCEedYRS3X7j3pfPV+Zr4='
WHERE
key_id = '6b3b2bee2ac9f1d74c3a25bf04bbf7d048c0f73c0fc296f31b36daadeb1d4b56'
AND (
token = 'ZrLH+X9D5FwJL4fZqiN8caiCEedYRS3X7j3pfPV+Zr4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)