UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M9WkGzFsjFePtO2uOzolRBR83nxGdyJoY9j6Gj1vl9k='
WHERE
key_id = 'fdfef682eee87064f7b12640c7864159bb1e7eb39c6e6f566f36c1766e3b3ec6'
AND (
token = 'M9WkGzFsjFePtO2uOzolRBR83nxGdyJoY9j6Gj1vl9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)