UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'bOgNqCz64a58cZOBDOuIex+QB6EmGlfXUA6rwXz3p08=' 
WHERE 
  key_id = 'edb2c837f2b26cd18c161c075cf04224a04bf419a5e89c0116a8ddd60b2b3e5a' 
  AND (
    token = 'bOgNqCz64a58cZOBDOuIex+QB6EmGlfXUA6rwXz3p08=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025