UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0Tvs00pRK2X35jtKIlW80G6AnVsSjlyTcRFnURXJ3zs=' 
WHERE 
  key_id = '04a85a7246a7c1d321ba564f62caa820cef96234a6b1af536a3b03c6c5149ec7' 
  AND (
    token = '0Tvs00pRK2X35jtKIlW80G6AnVsSjlyTcRFnURXJ3zs=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00031