UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kOCILkNghVRK0wlRvu8Gs3P/qc3J4dkcUrq2fXuBjCg='
WHERE
key_id = '0e4e3480f9a70a929afab65af3f33fb2be71953770e83fbf0cf6cce43e994291'
AND (
token = 'kOCILkNghVRK0wlRvu8Gs3P/qc3J4dkcUrq2fXuBjCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)