UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OlgJKqU4c1idQs+nVaiIeNPZUD0PW9F2baOqRmyhdaA='
WHERE
key_id = 'ce27df98aebf04ecb1e6487cbbb391b494d17b1cc335e5bb2fc9651045a16a17'
AND (
token = 'OlgJKqU4c1idQs+nVaiIeNPZUD0PW9F2baOqRmyhdaA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)