UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B+h6Tny3MxXWkGuuacmxChm8m16sZipWHRJuEPNJ1ic='
WHERE
key_id = 'c99ea12c604e1465f856ab65c84b00ba0155749ff951b938577225dfa2a42b48'
AND (
token = 'B+h6Tny3MxXWkGuuacmxChm8m16sZipWHRJuEPNJ1ic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)