UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+eCWexs4h8sPPCEpyi8QtO/fkRamHC9/EJRngse/2ag=' 
WHERE 
  key_id = '8c52f8b8396704c00e7c6e153bf5204958b19490fe4b068c75f142980e1f0a3d' 
  AND (
    token = '+eCWexs4h8sPPCEpyi8QtO/fkRamHC9/EJRngse/2ag=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024