UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8UZWyeOpvrhSjppJswtNwuqcZ7I3+QqOMzCiSuhFoRk=' 
WHERE 
  key_id = '121f7c18fe9a96a4b722d4759c0e512b26292c346643922da77df3b4ebf9d148' 
  AND (
    token = '8UZWyeOpvrhSjppJswtNwuqcZ7I3+QqOMzCiSuhFoRk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028