UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CQVf4vJaZZoGu3lvKam3+2Hb04s5bOEqhjThP/T/l4E='
WHERE
key_id = 'aa6e8a2d56ceb825c689f77daa1e10b1894baf27d2f4798f06625c908e149635'
AND (
token = 'CQVf4vJaZZoGu3lvKam3+2Hb04s5bOEqhjThP/T/l4E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)