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