UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5Q74GzD50yIh2cAsmrKjzaeRUDYnAANB9qEOP5D/7zs='
WHERE
key_id = '9818aae5335d4bc899f3627a269d259e2a312c4c85e828e8676394875f44bd49'
AND (
token = '5Q74GzD50yIh2cAsmrKjzaeRUDYnAANB9qEOP5D/7zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)